When you cluster the middle-tier and use a third-party database for SAS Shared Services, the following message might appear in SAS^® Deployment Wizard during the configuration of the cluster code:

Note: The applications in the list above might vary depending on what applications were originally configured.

To resolve this problem:

1. Open the server.xml file that resides in the SAS-configuration-directory\Lev1\Web\WebAppServer\SASServer1_1\conf\ directory.
2. In server.xml, locate the following resource tag and ensure that the URL attribute is correct, as shown below:
   

   <Resource auth="Container" driverClassName="org.postgresql.Driver"
             factory="com.sas.vfabrictcsvr.atomikos.BeanFactory" maxPoolSize="256"
             minPoolSize="10" name="sas/jdbc/SharedServices"
             password="${pw.sas.jdbc.SharedServices}" testQuery="select 1"
             type="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean"
             uniqueResourceName="sas/jdbc/SharedServices"
             url="jdbc:postgresql://database-host-name:database-port/SharedServices" user="dbms-owner"/>
   

   Note: The example above is for PostgreSQL. Your URL might be different.

   An incorrect URL attribute looks similar to the following example:

   <Resource auth="Container" driverClassName="org.postgresql.Driver"
             factory="com.sas.vfabrictcsvr.atomikos.BeanFactory" maxPoolSize="256"
             minPoolSize="10" name="sas/jdbc/SharedServices"
             password="${pw.sas.jdbc.SharedServices}" testQuery="select 1"
             type="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean"
             uniqueResourceName="sas/jdbc/SharedServices"
             url="jdbc:://database-host-name:database-port;/SharedServices" user="dbms-owner"/>
   

Operating System and Release Information